PreviousNextTracker indexSee it online !

(59/308) 497 - SQL plugin 1.02 bug with Postgres 7.2

Hi, there is a bug with and postgres 7.2.4 :
in the postgresVFS when I have the list of the
databases, if I double click on one of them the plugin
will try to get the schemaname, but it doesn't exists
in postgres 7.2.4
This query fails :
SELECT DISTINCT schemaname
FROM pg_tables

After a check the fields of the view pg_tables, the
field schemaname doesn't exists with this version of
postgres.
the existing fields are
tablename
tableowner
hasindexes
hasrules
hastriggers

Submitted kpouer - 2005-08-30 09:31:53 Assigned
Priority 5 Labels
Status open Group None
Resolution None

Comments

2007-03-16 17:36:02
svu

Logged In: YES
user_id=681
Originator: NO

How does Postgres 7.2.4 distinguishes different schemas/databases/...?

2007-03-16 17:36:02
svu

- **assigned_to**: nobody --> svu

2012-08-07 17:09:38
ezust

- **assigned_to**: svu --> nobody